use RD_COMMON;
go

insert into dbo.Star_UOMConversionFactors

select 
	SOURCE,
	SourceID,
	BusinessUnitCode,
	ItemNumber,
	RelatedUnitOfMeasure as UnitOfMeasure,
	UnitOfMeasure as RelatedUnitOfMeasure,
	UnitOfMeasureStructure,
	1.00/ConversionFactor as ConversionFactor,
	1.00/ConvFactorSecondaryToPrimary as ConvFactorSecondaryToPrimary,
	UserID,
	ProgramID,
	WorkStationID,
	DateUpdated,
	TimeOfDay,
	ExcludefromPO,
	ExcludefromSO,
	CodePurchasePriceCode,
	CodeSalesPriceCode,
	InsertIndicator,
	InsertDate,
	ChangeIndicator,
	ChangeDate,
	DeleteIndicator,
	DeleteDate,
	PurgeDate 
from 
	dbo.Star_UOMConversionFactors 
where 
	ConversionFactor <>0 and 
	ConvFactorSecondaryToPrimary<>0 and
	itemNumber not in  (36117,37415,38424,38425, 38426,43135,44426,45162,59375,68628)
